﻿CREATE TABLE [dbo].[DinnerFood] (
    [Id]          INT             IDENTITY (1, 1) NOT NULL,
    [Date]        NVARCHAR (50)   NULL,
    [FpId]        INT             NULL,
    [FpName]      NVARCHAR (50)   NULL,
    [HmtId]       INT             NULL,
    [HmtName]     NVARCHAR (50)   NULL,
    [HmtEndTime]  NVARCHAR (50)   NULL,
    [FoodId]      INT             NULL,
    [FoodName]    NVARCHAR (50)   NULL,
    [FoodPrice]   DECIMAL (18, 2) NULL,
    [RecCreateDt] DATETIME        NOT NULL,
    [RecStatus]   INT             NOT NULL,
    CONSTRAINT [PK__DinnerFo__3214EC07531856C7] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'主键，自增长', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'Id';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'日期，格式 yyyy-MM-dd', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'Date';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'餐牌ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'FpId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'餐牌名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'FpName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'饭点ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'HmtId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'饭点名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'HmtName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'饭点点餐截止时间,格式：HH:mm:ss', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'HmtEndTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'食品ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'FoodId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'食品名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'FoodName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'食品单价', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DinnerFood', @level2type = N'COLUMN', @level2name = N'FoodPrice';

